BEGIN TRANSACTION GO ALTER TABLE dbo.Appconfig ADD Signature2 varchar(50) NULL, Signature3 varchar(50) NULL GO COMMIT ALTER TABLE dbo.Appconfig ALTER COLUMN Signature VARCHAR(50);